package com.tarena.lbs.user.dao.repository.impl;

import com.alibaba.cloud.commons.lang.StringUtils;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.tarena.lbs.user.dao.mapper.AdminMapper;
import com.tarena.lbs.user.dao.mapper.UserMapper;
import com.tarena.lbs.user.dao.repository.AdminRepository;
import com.tarena.lbs.user.pojo.po.AdminPO;
import com.tarena.lbs.user.pojo.po.UserPO;
import com.tarena.lbs.user.pojo.query.AdminQuery;
import com.tarena.lbs.user.pojo.query.UserListQuery;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class AdminRepositoryImpl implements AdminRepository {

    @Autowired
    private AdminMapper adminMapper;
    @Autowired
    private UserMapper userMapper;

    @Override
    public AdminPO getAdminByPhone(String phone) {
        QueryWrapper<AdminPO> query = new QueryWrapper<>();
        query.eq("account_phone",phone);
        return adminMapper.selectOne(query);
    }

    @Override
    public AdminPO getAdminById(Integer id) {
        return adminMapper.selectById(id);
    }

    @Override
    public PageInfo<AdminPO> pagesList(AdminQuery query) {
        QueryWrapper<AdminPO> queryWrapper = assembleAdminQuery(query);
        //PageHelper.startPage 之间不能有代码
        PageHelper.startPage(query.getPageNo(), query.getPageSize());
        List<AdminPO> pos = adminMapper.selectList(queryWrapper);
        //selectList 数据库操作 之间不能有代码
        return new PageInfo<>(pos);
    }

    private QueryWrapper<AdminPO> assembleAdminQuery(AdminQuery query) {
        QueryWrapper<AdminPO> queryWrapper = new QueryWrapper<>();
        //1.accountPhone 账号手机号 相等查询 where account_phone=#{phone}
        if (StringUtils.isNotBlank(query.getAccountPhone())){
            queryWrapper.eq("account_phone",query.getAccountPhone());
        }
        //2.nickname 昵称 模糊查询 非空 where nickname like(%#{}%)
        if (StringUtils.isNotBlank(query.getNickname())){
            queryWrapper.like("nickname",query.getNickname());
        }
        return queryWrapper;
    }

    @Override
    public AdminPO getAdminByBusinessId(Integer businessId) {
        QueryWrapper<AdminPO> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("business_id", businessId);
        return adminMapper.selectOne(queryWrapper);
    }

    @Override
    public void insertAdmin(AdminPO adminPO) {
        adminMapper.insert(adminPO);
    }

    @Override
    public PageInfo<UserPO> pageListUser(UserListQuery query) {
        QueryWrapper<UserPO> queryWrapper = assembleUserQuery(query);
        PageHelper.startPage(query.getPageNo(), query.getPageSize());
        List<UserPO> pos = userMapper.selectList(queryWrapper);
        //selectList 数据库操作 之间不能有代码
        return new PageInfo<>(pos);
    }

    private QueryWrapper<UserPO> assembleUserQuery(UserListQuery query) {
        QueryWrapper<UserPO> queryWrapper = new QueryWrapper<>();
        //1.userName 用户姓名 模糊查询 非空 where user_name like(%#{}%)
        if (StringUtils.isNotBlank(query.getUserName())){
            queryWrapper.like("user_name",query.getUserName());
        }
        //2.phone 手机号 相等查询 where phone=#{phone}
        if (StringUtils.isNotBlank(query.getPhone())){
            queryWrapper.eq("phone",query.getPhone());
        }
        //3.providerType 渠道来源 相等查询 where provider_type=#{providerType}
        if (query.getProviderType()!=null){
            queryWrapper.eq("provider_type",query.getProviderType());
        }
        //4.startTime 注册开始时间 大于等于查询 where reg_time>=#{startTime}
        if (query.getStartTime()!=null){
            queryWrapper.ge("reg_time",query.getStartTime());
        }
        //5.endTime 注册结束时间 小于等于查询 where reg_time<=#{endTime}
        if (query.getEndTime()!=null){
            queryWrapper.le("reg_time",query.getEndTime());
        }
        return queryWrapper;
    }
}
